UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1TEEwys/9nqqsy432heOeN3OJu9vfACBcb42zUjK1Sk=' 
WHERE 
  key_id = 'bc75c7ebcb9ab85a00e224581f3293a317569ef35565d4f8b22d498be04a5159' 
  AND (
    token = '1TEEwys/9nqqsy432heOeN3OJu9vfACBcb42zUjK1Sk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023