UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Gn+3PWwOExTYEkcg8g0FtakOE1iunUbx7tHkZ61Ibg='
WHERE
key_id = '312a39170601a629bac283ce1b16758bc64962367abb5f451b94a1796d70a1e4'
AND (
token = '0Gn+3PWwOExTYEkcg8g0FtakOE1iunUbx7tHkZ61Ibg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)