UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qAfDM7YQSlRI50BfuSOTNzEaj/GTq6UhcRvtm1y6sAk='
WHERE
key_id = 'a7289ffb206b07a7a4da869e6dcace484ef1014af70f35f5a1dc3fbf93a03ec2'
AND (
token = 'qAfDM7YQSlRI50BfuSOTNzEaj/GTq6UhcRvtm1y6sAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)