UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bI8Wi0KEnh22IlUdSKQDsKJ6vNWC/xaajjzXmvnvsEw=' 
WHERE 
  key_id = 'd851ac38f20a80adc243a76d3edf78d07ba038906c2d2286ac0d5c2e6acbcc67' 
  AND (
    token = 'bI8Wi0KEnh22IlUdSKQDsKJ6vNWC/xaajjzXmvnvsEw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025