UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGzlVN8Tabb/vvChoquyjzfKFTK6RvpV7RLMnuRuymg='
WHERE
key_id = '46a60847b747ff69d528391dae414f610ffe60001390de62e5bcc5cf0b5786fb'
AND (
token = 'pGzlVN8Tabb/vvChoquyjzfKFTK6RvpV7RLMnuRuymg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)