UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FCQnvuUF32i7OI7siFqGylrJbAin6OvKEahAYM6fZ3w=' 
WHERE 
  key_id = '40c12a0c7ee8268558d1c45fa1853cec9855dec9ac105c0448dd7af9fb031f55' 
  AND (
    token = 'FCQnvuUF32i7OI7siFqGylrJbAin6OvKEahAYM6fZ3w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035