UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQzt9yqIPp1hxEjaJLk3A9DcMGsLZ5Mldn85W0V+hgg='
WHERE
key_id = '6e167284872d492add52f40cf63f2791ac1bbf6244baa5b955613c8e257f98f4'
AND (
token = 'LQzt9yqIPp1hxEjaJLk3A9DcMGsLZ5Mldn85W0V+hgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)