UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Z92rsFF9gOeYE63QME0Ha93k58FXthvQ5UpkcYt130='
WHERE
key_id = '4147a221dd56ee55c5386f0307a0f5a8a5df476942cb4485f9687546b2112b34'
AND (
token = '3Z92rsFF9gOeYE63QME0Ha93k58FXthvQ5UpkcYt130='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)