UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z+yyH7A7/7ZRilTXacnGOSt27L/fIc8W0Npgd6jSamI='
WHERE
key_id = '81913d3892dadd0bac4807cc894cc6d67af68a7f47ad97a5dc34d6ac4eb25841'
AND (
token = 'z+yyH7A7/7ZRilTXacnGOSt27L/fIc8W0Npgd6jSamI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)