UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5jJ3H9u8K08Hr4jInE3Y1+4FYVgiJuxonyKOiUb/fJ0=' 
WHERE 
  key_id = '6b437a9087cf7779c6b83b9d01893f43cd278f06a6e36c8f425f7bc40a19f870' 
  AND (
    token = '5jJ3H9u8K08Hr4jInE3Y1+4FYVgiJuxonyKOiUb/fJ0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021