UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vXvpcWhR8D5e6zxxenGctcyGNC4LJ71du99PK98mw1U='
WHERE
key_id = '4c180f31b5783a3faa6d848885ce20dc3594e12f1f3428b586fd52c74a8e8089'
AND (
token = 'vXvpcWhR8D5e6zxxenGctcyGNC4LJ71du99PK98mw1U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)