UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ecICZhcLDeGS905PmuuZzd3kjJFVC4QCsmwzG1uVVo='
WHERE
key_id = '653bb7adfc397bef26cd0fb3fffca26e02988f908a8c44113c3d927eefe99d3f'
AND (
token = '6ecICZhcLDeGS905PmuuZzd3kjJFVC4QCsmwzG1uVVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)