UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UM429ptMQ4t7EtpCFserA1MKzoLsP7GzsAr3j9/V5hk=' 
WHERE 
  key_id = 'c64a877e43f51897a1f670062b2b5194dca7f445c8400bf81c4f8dc1747e5269' 
  AND (
    token = 'UM429ptMQ4t7EtpCFserA1MKzoLsP7GzsAr3j9/V5hk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037