UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HZEPmbJy6KerfcUxgl1tbjvNFEZyo/ChvajYsnkf3Qs='
WHERE
key_id = '300471ec0523a46c48555738ad48a879c0cd417339e58319a6007f64dbb369a0'
AND (
token = 'HZEPmbJy6KerfcUxgl1tbjvNFEZyo/ChvajYsnkf3Qs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)