UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XDYuQ5/8sr1dpWicnpOc3Tl90st42s7VDSc7+Pu+NoA='
WHERE
key_id = 'ccdf9f0784488caa24f860ccaf2b9213ae587ee7c0589aa2511c4554bb6572ce'
AND (
token = 'XDYuQ5/8sr1dpWicnpOc3Tl90st42s7VDSc7+Pu+NoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)