UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'URcwx33JNAkhLzm0ZPvZmm3u8lH6c0cJDL4+FJ1Y+uo=' 
WHERE 
  key_id = '5d6c0cf3d9dde7b979679532aff430bf460768aa485cc65e3970c357a1e82402' 
  AND (
    token = 'URcwx33JNAkhLzm0ZPvZmm3u8lH6c0cJDL4+FJ1Y+uo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044