UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9HePNAYMtJ2tbdA8UTXTuct99ZgW2YL8Zx3UsSSOJ5o='
WHERE
key_id = 'd45582962ebc85f868f5bf794021de889e64d6edf452c8497009f7712ee16345'
AND (
token = '9HePNAYMtJ2tbdA8UTXTuct99ZgW2YL8Zx3UsSSOJ5o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)