UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vJn8SPVO+lk7BgN9+Mrkhsabx3YENAHsGLeQnIr4iik='
WHERE
key_id = '6be9c47a964e677349afd4d890ac076fd4cac6d0c9bbd17ed839cf27c70ed2fe'
AND (
token = 'vJn8SPVO+lk7BgN9+Mrkhsabx3YENAHsGLeQnIr4iik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)