UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aWHuwop8KGP4w1mFucUORx77UAre8BwOBZfEn/otI0c='
WHERE
key_id = '31a96b8f34da08097247ddc40a21c7b51192b6f96f042a213b3ec679a4ee6669'
AND (
token = 'aWHuwop8KGP4w1mFucUORx77UAre8BwOBZfEn/otI0c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)