UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/nJ6n6Jd3hP2O9yk00+VPojiuklHge7tpuaWr9zENMw='
WHERE
key_id = 'c05117b75bc68cb5227436034eff47ba2541b75bcd9f293aea5c7984e865b7cb'
AND (
token = '/nJ6n6Jd3hP2O9yk00+VPojiuklHge7tpuaWr9zENMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)