UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BROnX+hSh6aP9ROSA5uVS9/lngHeVasYk/I0s/lxQWk='
WHERE
key_id = '3d293fb638e53c8d7ae3cd898ec445e56014137db5b9087af49bc39a94fbcf8f'
AND (
token = 'BROnX+hSh6aP9ROSA5uVS9/lngHeVasYk/I0s/lxQWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)