UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'OryKmcpD6Tz88TGeuDMP33nl6IWTyx2/ozCjkF/ALcI=' 
WHERE 
  key_id = '9ebe0cc9f17c68aed0c09e4a4ea8fe07716925b2a8f81c1bcdd06df903e01ef4' 
  AND (
    token = 'OryKmcpD6Tz88TGeuDMP33nl6IWTyx2/ozCjkF/ALcI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047