UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Rxlgkh6ovYYUZWQbu8FlZPXMs0J5rtcDEkS4ftV8IG8=' 
WHERE 
  key_id = '8a51fd5d28c6ba7d1881bb208f27fc18787c1eb394d28656e64aa01ad09bcc99' 
  AND (
    token = 'Rxlgkh6ovYYUZWQbu8FlZPXMs0J5rtcDEkS4ftV8IG8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025