UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c9AyW+ZB3vpmFUmK6pw1YhnYe7X3AWnzW7E00YscLbQ='
WHERE
key_id = '21167212cfa814720b520e832c9f1e38a52c1668ffee2117adafca9ba15b56a7'
AND (
token = 'c9AyW+ZB3vpmFUmK6pw1YhnYe7X3AWnzW7E00YscLbQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)