UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hx9ZQ0WWudqRmAE0/+8877prxCfkb6wKJH9mifT9le4='
WHERE
key_id = '96824901bbfd13bd44797317af04f5d758e4127df69ba6cf605e853e46abff63'
AND (
token = 'Hx9ZQ0WWudqRmAE0/+8877prxCfkb6wKJH9mifT9le4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)