UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'msUC/UwJ5IQGyUhA/xLnKAvmfnca+ePfducuezFQroY='
WHERE
key_id = '8ab01688bbc3b7ff7e71b08b38fa8a778046a6b0d4b7e7841404b3fee5949b77'
AND (
token = 'msUC/UwJ5IQGyUhA/xLnKAvmfnca+ePfducuezFQroY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)