UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2bsq4CezaiGgyLsnHtCiRWs/b6Y6Frpy0BZKD6/wCIk='
WHERE
key_id = '1d74122e3bb4e55f2018a43085675a681116fc4ef67a0c3e443d09f0c322e334'
AND (
token = '2bsq4CezaiGgyLsnHtCiRWs/b6Y6Frpy0BZKD6/wCIk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)