UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0/lM1Alr44Dp8jsdmmtvbVfw2wgj91suzyRJ1X/OKm4='
WHERE
key_id = 'ff642a848d2767388ed21ce11f1f72b18f6a84e386f5e3781ea2c930a8903794'
AND (
token = '0/lM1Alr44Dp8jsdmmtvbVfw2wgj91suzyRJ1X/OKm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)