UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lK7LEJHz6aKlU+xbVYn63etASHO/ic8Z3ofAJt0IU2s='
WHERE
key_id = 'd4ac734a769f8694b468cad3e7d506423219c57fd45f645b108ea689c90b9db6'
AND (
token = 'lK7LEJHz6aKlU+xbVYn63etASHO/ic8Z3ofAJt0IU2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)