UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nUy2pmbxIIue3fD2CQkwFdMz2YhKZUl3xiw6K0zKv6g='
WHERE
key_id = '654c0b30994015932324c52693ddbe5553ee1e9793d507bf457db099c52b1271'
AND (
token = 'nUy2pmbxIIue3fD2CQkwFdMz2YhKZUl3xiw6K0zKv6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)