UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cCqRGsYuXUwPHr0X9kcnN+aDmC2kkpSjl/ByGfaWCbQ='
WHERE
key_id = '4f47881c9673b15b1f6661dbd56f4b566f1eea51b7e803ef55fdaebf7026770d'
AND (
token = 'cCqRGsYuXUwPHr0X9kcnN+aDmC2kkpSjl/ByGfaWCbQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)