UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RC7EYwwgkjLziqIbnKpKW6Gcs06f5RWS34B7L+J7rZQ=' 
WHERE 
  key_id = 'eb317c2b87bd2f72ca3c6ee4e9e06a8f6e61863023463928db795539b9783bc9' 
  AND (
    token = 'RC7EYwwgkjLziqIbnKpKW6Gcs06f5RWS34B7L+J7rZQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044