UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zE5h5LcT7GEnK01HfbjK9SS28uhUY0AyXlDEA9XiYNQ='
WHERE
key_id = '5460882f915503606e80ccba84b076c8296946ea830552edccae91feffaf6d33'
AND (
token = 'zE5h5LcT7GEnK01HfbjK9SS28uhUY0AyXlDEA9XiYNQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)