UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GWNJZip6aS7/V/szmWMf9Q+880jxdD3o8dmn72c6NB4=' 
WHERE 
  key_id = '4655e7620921e5ef27e5ca161586d6c8a982c3a9fa229991f4601a7c73b988fd' 
  AND (
    token = 'GWNJZip6aS7/V/szmWMf9Q+880jxdD3o8dmn72c6NB4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032