UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sFTReWLhhSS502oV6PUq0ESIqhnO/qhL3k7M4erPcGQ=' 
WHERE 
  key_id = '26267ad771748d364be4a0052710e16c9a072d2f3dff6230e2e7e1beb908f0d8' 
  AND (
    token = 'sFTReWLhhSS502oV6PUq0ESIqhnO/qhL3k7M4erPcGQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029