UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Sfmqip8iHBEdFaiRBCoRNWv8TUzb1NybsW5MHVr0L4='
WHERE
key_id = '4ed76985a64285f97b5996604764c1c36630b865c82352079f6d7ecf11165150'
AND (
token = '0Sfmqip8iHBEdFaiRBCoRNWv8TUzb1NybsW5MHVr0L4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)