UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HmG74+qXJ5xurjJSekjh6r2hk6QiwKNGr25b8fT2iFU='
WHERE
key_id = 'c9f0529c8ab183ecdde478ccc1a042532c44931b45c69ec378c19c4ec5944ca8'
AND (
token = 'HmG74+qXJ5xurjJSekjh6r2hk6QiwKNGr25b8fT2iFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)