UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zHRM+E0CPhUdv5JfT0DeHzsEnMJh2dLsVKkFoxvDSHk=' 
WHERE 
  key_id = '69ba0bbe8f21c74843cd8d71ccc594c73818d74454523d0951295916a8572031' 
  AND (
    token = 'zHRM+E0CPhUdv5JfT0DeHzsEnMJh2dLsVKkFoxvDSHk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032