UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tURCFafFDMLPqP6KFZlJR4orxxw/ueGAYA+henA4bi0='
WHERE
key_id = '3f96d4386442e48f092a490ee4462c56c90a567ee70769f1517063f5c3aa5bf5'
AND (
token = 'tURCFafFDMLPqP6KFZlJR4orxxw/ueGAYA+henA4bi0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)