UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 's6lcA1UxD0a8KcG6gJCY7j045OsoeNWgRvLu/VZ1RWw=' 
WHERE 
  key_id = 'ed141273fca25c2d56ccbf168d7a907775cf10dc1b09ef14dea1157e9c1c896e' 
  AND (
    token = 's6lcA1UxD0a8KcG6gJCY7j045OsoeNWgRvLu/VZ1RWw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00051