UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PP6VY77ueFI8QKK4M5mllI5NGBywIWnlN4JjbyFxb/w='
WHERE
key_id = 'b813394d8a19ceda0a5ca357b52b8e18c1e199cfb7a523a8135b4571e63efc9c'
AND (
token = 'PP6VY77ueFI8QKK4M5mllI5NGBywIWnlN4JjbyFxb/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)