UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4jlMXIDQ6ocWBDzEme9hFIo6bWQLh+HPi8gggpdS+kA='
WHERE
key_id = 'cf8a7bc48ae3dca2571d7f522c2080b9462356160d128ad8564b4816648a89ff'
AND (
token = '4jlMXIDQ6ocWBDzEme9hFIo6bWQLh+HPi8gggpdS+kA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)