UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wWmmbc3Z8mISwNU63M3EyouUW3pZvAI+s85eYEibL9w=' 
WHERE 
  key_id = '629bd05016a1f5ffb9f6fa4cb5e8cdd27bf4b2b35547900d83c2038af0b4059a' 
  AND (
    token = 'wWmmbc3Z8mISwNU63M3EyouUW3pZvAI+s85eYEibL9w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021