UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n7hcL6RcYDf2E2top5eUnrDqu7268ZuQvM52qYOfE0o='
WHERE
key_id = 'cc860edc8df0f24535e7e04ebca32fa6915f5645fd505988fb8aaafce720c144'
AND (
token = 'n7hcL6RcYDf2E2top5eUnrDqu7268ZuQvM52qYOfE0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)