UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9zrQuKR6fvO+iScx0uhx/7WYiYcMp8PxZARQTy9U0fM='
WHERE
key_id = 'd5536cfa0fbf0eeca7b27e8fba48053c96dfc2f1f84b83fd2a6f6fcf4a4bccfb'
AND (
token = '9zrQuKR6fvO+iScx0uhx/7WYiYcMp8PxZARQTy9U0fM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)