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