UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2MSGXriQT2k7tSYQCCJDlA7qj8jzSsy7mw5o7o++DyI='
WHERE
key_id = '6e542ec5b96b9ba09979b181e0e24b4892dfc8746f794261a9ff73063f81ef96'
AND (
token = '2MSGXriQT2k7tSYQCCJDlA7qj8jzSsy7mw5o7o++DyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)