UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HBsdKnm1r10QZtzatVZzLFQ789cBxLf0Q+fPA/t0Ils='
WHERE
key_id = '7b2c969affc2322a9049c6cf03d51c2e321718fda5a29d84082c73c799618f15'
AND (
token = 'HBsdKnm1r10QZtzatVZzLFQ789cBxLf0Q+fPA/t0Ils='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)