UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lBPNFSx8H1eG254aQ7bjF6XzakLTNl/r1VcuREgH7+k=' 
WHERE 
  key_id = '53d546fb57153e20ec256ee6f0ea95a8b42c2fefee7b587bfcbf3ea2b4d4fff2' 
  AND (
    token = 'lBPNFSx8H1eG254aQ7bjF6XzakLTNl/r1VcuREgH7+k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018