UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vBKn2DfJcE83NIVZEtfmHvpjliSXr1bGD9k08NfLMuA='
WHERE
key_id = '54e39e6ebb3048be2c376765473d4eabde10f2000fe1d5100420c284deee1346'
AND (
token = 'vBKn2DfJcE83NIVZEtfmHvpjliSXr1bGD9k08NfLMuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)