UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X+JzL7jxVepPH1IovE0rUeyuDGIb8rRDkugsN8iyRik='
WHERE
key_id = '3cf50b41c903697c1cc28f47a8203ccc9d37b75fbcc301c71406864ccccefdb4'
AND (
token = 'X+JzL7jxVepPH1IovE0rUeyuDGIb8rRDkugsN8iyRik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)