UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8c9YSN0qLFKxTM4TmQZNckKHKZU+GSj+wCul59ftFEA='
WHERE
key_id = '59a890687c241f42344ba589b4c76069394bc91f0cd9181a4cdfcfdeb3db3421'
AND (
token = '8c9YSN0qLFKxTM4TmQZNckKHKZU+GSj+wCul59ftFEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)