UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0uRk3KHIX0KxoUx45GumF9LvJ+4dIzKvvFmogMaTA+E='
WHERE
key_id = '8affb7fdbf5f729700f23438bfc4f6a95079649bf0a0cec9b37847e320c88840'
AND (
token = '0uRk3KHIX0KxoUx45GumF9LvJ+4dIzKvvFmogMaTA+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)