UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7xfbi0IQZkigI3BIwTfUK7dGA2o7yC1BQeyKvYdwF6k='
WHERE
key_id = '4b2fa6c8ef2e7fb8a45fb09bc92d16a6410168cec87c1597b7ffda2ac98a9c10'
AND (
token = '7xfbi0IQZkigI3BIwTfUK7dGA2o7yC1BQeyKvYdwF6k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)