UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hpNRmZD6lwlKpXN8qtG83pzsRtStmVBNVfD1Gg+wPmY='
WHERE
key_id = 'f381b72f84d90bfd4a3986800b71adc91a5bf959a02b1b0035f2e847557c31fb'
AND (
token = 'hpNRmZD6lwlKpXN8qtG83pzsRtStmVBNVfD1Gg+wPmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)