UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8bcsu3vPGgZXFY7xudb6wKMLERL5qU/eKjFxXt58zxs='
WHERE
key_id = '9a016f937505814332ec9ed2a46881345720e5e46e93b9cf3ec3d56818a5754d'
AND (
token = '8bcsu3vPGgZXFY7xudb6wKMLERL5qU/eKjFxXt58zxs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)